﻿//===========================================================================================================================
// Cuberry - http://www.cuberry.net
// Copyright (c) 2012
// by Peacequare® - Amir Moussa
//===========================================================================================================================
// This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License 
// as published by the Free Software Foundation, either version 3 of the License, or any later version.
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions 
// of the Software.
//
// This program is distributed in the hope that it will be useful.
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL 
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF 
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
// DEALINGS IN THE SOFTWARE.
//
// See the GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.
//===========================================================================================================================

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using P2.Cuberry.Framework.BOLBase;
using P2.Cuberry.Framework.Helper;
using P2.Cuberry.Framework.Helper.Configuration;
using P2.Cuberry.Framework.Security;
using P2.Cuberry.Modules.Framework.ModuleManager.DAL;

namespace P2.Cuberry.Modules.Framework.ModuleManager.BusinessEntities
{
    public class MenuMainMenu
    {
        public int MenuItemId { get; set; }
        public string MenuItemName { get; set; }
        public string ItemIconName { get; set; }
        public int? SortOrder { get; set; }
        public bool? Active { get; set; }

        public ObservableCollection<MenuSubMenu> SubMenus { get; set; }

        public static ObservableCollection<MenuMainMenu> GetMainMenus()
        {
            ObservableCollection<MenuMainMenu> menuItems = new ObservableCollection<MenuMainMenu>();

            string connectionString = ConfigurationSetUp.GetEntConnectionString("Business", Properties.Settings.Default.EntityResources);
            using (ModuleManagerDataContext db = new ModuleManagerDataContext(connectionString))
            {
                var result = from q in db.MenuMainMenu
                             orderby q.SortOrder ascending
                                select q;

                if (result.Count() > 0 )
                {
                    foreach(DAL.MenuMainMenu menu in result)
                    {

                        MenuMainMenu menuToAdd = new MenuMainMenu
                        {
                            MenuItemId = menu.MenuItemID,
                            MenuItemName = menu.MenuItemName,
                            ItemIconName = menu.ItemIconName,
                            Active = menu.Active,
                            SortOrder = menu.SortOrder
                        };

                        var subMenuResult = from tranItem in db.MenuSubMenu
                                           where tranItem.MainMenuItemID == menu.MenuItemID
                                           orderby tranItem.SortOrder ascending
                                           select tranItem;

                        ObservableCollection<MenuSubMenu> subMenuItems = new ObservableCollection<MenuSubMenu>();

                        if (subMenuResult.Count() > 0)
                        {
                            foreach (DAL.MenuSubMenu subMenu in subMenuResult)
                            {
                                subMenuItems.Add(new MenuSubMenu 
                                                    { SubMenuItemId = subMenu.SubMenuItemID, 
                                                        MenuItemName = subMenu.MenuItemName,
                                                        ItemIconName = @"Images/" + subMenu.ItemIconName, 
                                                        SortOrder = subMenu.SortOrder, 
                                                        MainMenuItemId = subMenu.MainMenuItemID ?? 0, 
                                                        ModuleName = subMenu.ModuleName,
                                                        Parent = menuToAdd
                                                    }
                                                );
                            }
                        }

                        menuToAdd.SubMenus = subMenuItems;
                        menuItems.Add(menuToAdd);
                    }
                }
            }

            return menuItems;
        }
    }
}
